----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  Z:\GWA4 - Cantoni\D_Ergebnisse\evs93_cantoni_20140812tables5_6.log
  log type:  text
 opened on:  12 Aug 2014, 11:17:41

. 
. ***************************************************************************
. ***************************************************************************
. *** Titel des Projekts: <Clueless? The impact of television on consumption behavior.>
. *** Datengrundlage: <EVS 1993>
. *** Dateiname des Programmcodes: evs93_cantoni_20140812tables5_6.do
. *** erstellt: <2014/08/12> 
. *** von: <Davide Cantoni> 
. *** E-Mail: <cantoni@lmu.de> 
. *** Tel.: <0176/21816773> 
. *** Dateiname der Output-Files: <evs93_cantoni_20140812tables5_6.log> 
. ***                     <evs93_cantoni_20140812tables5_6.txt>  
. *** 
. *** Grundriss des Programms: <Programm zur Untersuchung von 
. *** Unterschieden im Konsumverhalten zwischen ehem. DDR-Regionen mit Zugang 
. *** zu westlichen Fernsehsendern und solchen ohne.>
. *** 
. *** Verwendete Variablen: 
. *** Originalvariablen:  <mehrere>
. *** 
. *** Neu angelegte Variablen: <bula*: Bundesland-Dummy
. ***                             berlinost: Dummy fuer Haushalte in Ostberlin
. ***                             smallcity: Kleinstadt-Dummy
. ***                             age: Ungefaehres Alter 
. ***                             agesq: (Ungefaehres Alter)^2
. ***                             single: Alleinstehend-Dummy
. ***                             german: Dummy fuer deutsche Nationalitaet
. ***                             female: Dummy fuer Frauen
. ***                             employed: Dummy fuer Vollzeitbeschaeftigte 
. ***                             retired: Dummy fuer Rentner 
. ***                             onwelfare: Dummy fuer Sozialhilfeempfaenger 
. ***                             treat: Neucodierung von ard_signalstaerke
. ***                             netincome: Umbenennung von ef19
. ***                             disposableincome: Umbenennung von ef21
. ***                             weight: Umbenennung von ef66
. ***                             ef100001-ef100014: Konsumausgaben, fuer die Werbungsinformationen bereitstehen
. ***                             ef100015: Uebrige Konsumausgaben (ohne Werbung)
. ***                             ef: Konsumausgaben (nach Umformung des Datensatzes)
. ***                             logef: Logarithmus der Konsumausgaben (nach Umformung des Datensatzes)
. ***                             log0ef: Logarithmus der Konsumausgaben+1 (nach Umformung des Datensatzes)>
. ***
. *** Gewichtungsvariablen: <ef66: Umbenannt als "weight">
. ***
. ***************************************************************************
. ***************************************************************************
. 
.         
.         **** Version festlegen
. 
. version 9.1

. 
.         **** Bildschirmausgabe steuern
. 
. set more off

. 
.         **** Arbeitsspeicher festlegen
. 
. set mem 750m

. 
.         **** Arbeitsverzeichnis festlegen
. 
. cd "Z:\GWA4 - Cantoni\D_Ergebnisse\"
Z:\GWA4 - Cantoni\D_Ergebnisse

. 
.         **** Datensatz vorbereiten
. 
. qui do "Z:\GWA4 - Cantoni\C_Programm\evs93_cantoni_20140812preparedata.do"

. 
.         *** Aggregiertes Konsumverhalten 
.         *** (aggregate consumption behavior - Table 5)
. 
. drop if berlinost==1
(791 observations deleted)

. 
. tab treat saving01

           |       saving01
     treat |         0          1 |     Total
-----------+----------------------+----------
         0 |       273        997 |     1,270 
         1 |     1,871      6,164 |     8,035 
-----------+----------------------+----------
     Total |     2,144      7,161 |     9,305 


. 
. replace ln_dispincome=100*ln_dispincome
(9305 real changes made)

. replace ln_ef100100=100*ln_ef100100
(9305 real changes made)

. replace saving01=100*saving01
(7161 real changes made)

. 
. local controls "treat ln_dispincome age agesq kids single female german employed retired onwelfare bula* smallcity [w=weight]"

. 
. reg ln_dispincome treat age agesq kids single female german employed retired onwelfare bula* smallcity [w=weight], robust cluster(muni)
(analytic weights assumed)
(sum of wgt is   6.0721e+06)

Linear regression                                      Number of obs =    9305
                                                       F( 15,  1358) =  420.55
                                                       Prob > F      =  0.0000
                                                       R-squared     =  0.6423
                                                       Root MSE      =    31.9

                                (Std. Err. adjusted for 1359 clusters in muni)
------------------------------------------------------------------------------
             |               Robust
ln_dispinc~e |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
       treat |  -1.006736   1.865095    -0.54   0.589    -4.665516    2.652044
         age |   3.293714   .2600613    12.67   0.000     2.783548    3.803879
       agesq |  -.0295038   .0027505   -10.73   0.000    -.0348994   -.0241082
        kids |    9.49697   .7469048    12.72   0.000     8.031757    10.96218
      single |   -58.2547   1.540992   -37.80   0.000    -61.27769   -55.23172
      female |  -7.248729   1.103023    -6.57   0.000    -9.412543   -5.084914
      german |   .3466582   12.14337     0.03   0.977    -23.47513    24.16845
    employed |   35.26997   1.495564    23.58   0.000      32.3361    38.20383
     retired |   7.235014   2.358293     3.07   0.002     2.608721    11.86131
   onwelfare |  -24.35914   3.435582    -7.09   0.000    -31.09876   -17.61952
       bula1 |   5.972869   2.657254     2.25   0.025     .7601004    11.18564
       bula2 |  -4.404946   3.066221    -1.44   0.151    -10.41999    1.610099
       bula3 |    -.84124   2.243019    -0.38   0.708    -5.241397    3.558917
       bula4 |  -1.627186   2.272005    -0.72   0.474    -6.084207    2.829835
       bula5 |          0  (omitted)
       bula6 |          0  (omitted)
   smallcity |   -3.48665   1.633834    -2.13   0.033    -6.691762   -.2815367
       _cons |   960.8519   14.28374    67.27   0.000     932.8313    988.8725
------------------------------------------------------------------------------

.         outreg2 using evs93_cantoni_20140812tables5_6, br dec(4) ctitle("`e(depvar)', , Bula FE, all controls, no EastBerlin") replace
C:\Program Files (x86)\Stata12\ado\base/o/outreg2.ado
dir : seeout

. reg ln_ef100100 `controls', robust cluster(muni)
(analytic weights assumed)
(sum of wgt is   6.0721e+06)

Linear regression                                      Number of obs =    9305
                                                       F( 16,  1358) =  582.50
                                                       Prob > F      =  0.0000
                                                       R-squared     =  0.6919
                                                       Root MSE      =  28.343

                                 (Std. Err. adjusted for 1359 clusters in muni)
-------------------------------------------------------------------------------
              |               Robust
  ln_ef100100 |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
--------------+----------------------------------------------------------------
        treat |  -.8299894   1.361159    -0.61   0.542    -3.500192    1.840213
ln_dispincome |   .6515331   .0164662    39.57   0.000     .6192312    .6838349
          age |   1.792709   .2517751     7.12   0.000     1.298799     2.28662
        agesq |  -.0196851    .002828    -6.96   0.000    -.0252328   -.0141374
         kids |   2.505346    .672333     3.73   0.000     1.186422     3.82427
       single |   -14.9167   1.730459    -8.62   0.000    -18.31136   -11.52204
       female |   .0950274   1.046495     0.09   0.928    -1.957895     2.14795
       german |  -16.60702   15.35786    -1.08   0.280    -46.73472    13.52068
     employed |  -3.817408   1.538975    -2.48   0.013    -6.836434   -.7983815
      retired |   6.068497   2.357522     2.57   0.010     1.443717    10.69328
    onwelfare |  -2.348406   2.366014    -0.99   0.321    -6.989846    2.293034
        bula1 |   1.993673   2.268399     0.88   0.380    -2.456273    6.443619
        bula2 |  -1.200977   2.730418    -0.44   0.660    -6.557271    4.155318
        bula3 |  -1.297434    2.07475    -0.63   0.532    -5.367497    2.772629
        bula4 |  -2.082839   2.431989    -0.86   0.392    -6.853702    2.688023
        bula5 |          0  (omitted)
        bula6 |          0  (omitted)
    smallcity |  -4.110594   1.226928    -3.35   0.001    -6.517474   -1.703714
        _cons |   329.3448   22.50724    14.63   0.000     285.1921    373.4975
-------------------------------------------------------------------------------

.         outreg2 using evs93_cantoni_20140812tables5_6, br dec(4) ctitle("`e(depvar)', , Bula FE, all controls, no EastBerlin") 
C:\Program Files (x86)\Stata12\ado\base/o/outreg2.ado
dir : seeout

. reg saving01 `controls', robust cluster(muni)
(analytic weights assumed)
(sum of wgt is   6.0721e+06)

Linear regression                                      Number of obs =    9305
                                                       F( 16,  1358) =   11.48
                                                       Prob > F      =  0.0000
                                                       R-squared     =  0.0440
                                                       Root MSE      =  42.554

                                 (Std. Err. adjusted for 1359 clusters in muni)
-------------------------------------------------------------------------------
              |               Robust
     saving01 |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
--------------+----------------------------------------------------------------
        treat |   .9368419   2.279489     0.41   0.681     -3.53486    5.408544
ln_dispincome |   .1725679   .0198013     8.71   0.000     .1337234    .2114124
          age |   -1.29118   .4839573    -2.67   0.008    -2.240565   -.3417954
        agesq |   .0152235   .0049328     3.09   0.002     .0055467    .0249003
         kids |  -.3644157    .816738    -0.45   0.656    -1.966621    1.237789
       single |   1.788671   2.631424     0.68   0.497    -3.373425    6.950768
       female |   .2594694   1.647003     0.16   0.875    -2.971476    3.490415
       german |   27.01687    15.4835     1.74   0.081    -3.357304    57.39104
     employed |   4.746469    2.61265     1.82   0.069    -.3787988    9.871736
      retired |   -6.65262   3.452012    -1.93   0.054    -13.42447    .1192342
    onwelfare |   3.208666    4.48059     0.72   0.474    -5.580963    11.99829
        bula1 |  -2.612095   3.278357    -0.80   0.426    -9.043288    3.819099
        bula2 |  -.0056032   4.292368    -0.00   0.999    -8.425994    8.414788
        bula3 |   1.604642    2.70288     0.59   0.553    -3.697632    6.906916
        bula4 |   .7663709   3.489916     0.22   0.826     -6.07984    7.612582
        bula5 |          0  (omitted)
        bula6 |          0  (omitted)
    smallcity |   1.834993   1.785185     1.03   0.304    -1.667027    5.337014
        _cons |  -113.4059   25.99118    -4.36   0.000    -164.3931   -62.41866
-------------------------------------------------------------------------------

.         outreg2 using evs93_cantoni_20140812tables5_6, br dec(4) ctitle("`e(depvar)', , Bula FE, all controls, no EastBerlin") 
C:\Program Files (x86)\Stata12\ado\base/o/outreg2.ado
dir : seeout

. 
.         *** Kreditaufnahme
.         *** (credit taking behavior)
. 
. tab treat int_conscredit01 

           |   int_conscredit01
     treat |         0          1 |     Total
-----------+----------------------+----------
         0 |       877        393 |     1,270 
         1 |     5,352      2,683 |     8,035 
-----------+----------------------+----------
     Total |     6,229      3,076 |     9,305 


. tab treat int_overdraft01

           |    int_overdraft01
     treat |         0          1 |     Total
-----------+----------------------+----------
         0 |     1,109        161 |     1,270 
         1 |     7,241        794 |     8,035 
-----------+----------------------+----------
     Total |     8,350        955 |     9,305 


. 
. replace int_conscredit01=100*int_conscredit01
(3076 real changes made)

. replace int_overdraft01=100*int_overdraft01
(955 real changes made)

. 
. reg int_conscredit01 `controls', robust cluster(muni)
(analytic weights assumed)
(sum of wgt is   6.0721e+06)

Linear regression                                      Number of obs =    9305
                                                       F( 16,  1358) =   81.13
                                                       Prob > F      =  0.0000
                                                       R-squared     =  0.1152
                                                       Root MSE      =  43.571

                                 (Std. Err. adjusted for 1359 clusters in muni)
-------------------------------------------------------------------------------
              |               Robust
int_conscr~01 |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
--------------+----------------------------------------------------------------
        treat |   1.728673    2.40611     0.72   0.473    -2.991422    6.448769
ln_dispincome |   .0595505   .0198924     2.99   0.003     .0205274    .0985736
          age |   -.247538   .3180836    -0.78   0.437    -.8715266    .3764506
        agesq |  -.0029167    .003021    -0.97   0.334    -.0088431    .0030097
         kids |   3.043963    1.18161     2.58   0.010     .7259841    5.361942
       single |  -1.154983   2.331703    -0.50   0.620    -5.729113    3.419146
       female |  -4.784149   1.883638    -2.54   0.011    -8.479306   -1.088993
       german |   4.980913   12.14211     0.41   0.682    -18.83842    28.80025
     employed |   5.361051   3.332515     1.61   0.108    -1.176386    11.89849
      retired |  -.3013313   5.261556    -0.06   0.954    -10.62299    10.02033
    onwelfare |   8.018744   4.707475     1.70   0.089    -1.215968    17.25346
        bula1 |   6.250186   2.895156     2.16   0.031     .5707224    11.92965
        bula2 |  -.3146222   2.415636    -0.13   0.896    -5.053406    4.424162
        bula3 |  -1.233966   2.510733    -0.49   0.623    -6.159301     3.69137
        bula4 |   2.492349   2.253724     1.11   0.269    -1.928809    6.913507
        bula5 |          0  (omitted)
        bula6 |          0  (omitted)
    smallcity |  -2.488521   1.663099    -1.50   0.135    -5.751043    .7740008
        _cons |  -20.70951    25.3695    -0.82   0.414    -70.47717    29.05815
-------------------------------------------------------------------------------

.         outreg2 using evs93_cantoni_20140812tables5_6, br dec(4) ctitle("`e(depvar)', , Bula FE, all controls, no EastBerlin") 
C:\Program Files (x86)\Stata12\ado\base/o/outreg2.ado
dir : seeout

. reg int_overdraft01 `controls', robust cluster(muni)
(analytic weights assumed)
(sum of wgt is   6.0721e+06)

Linear regression                                      Number of obs =    9305
                                                       F( 16,  1358) =   16.46
                                                       Prob > F      =  0.0000
                                                       R-squared     =  0.0368
                                                       Root MSE      =  28.261

                                 (Std. Err. adjusted for 1359 clusters in muni)
-------------------------------------------------------------------------------
              |               Robust
int_overdr~01 |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
--------------+----------------------------------------------------------------
        treat |  -1.373681   1.575507    -0.87   0.383    -4.464373     1.71701
ln_dispincome |   .0579835   .0141386     4.10   0.000     .0302477    .0857193
          age |  -.2696682   .1930757    -1.40   0.163    -.6484271    .1090907
        agesq |   .0000166   .0020453     0.01   0.994    -.0039957    .0040289
         kids |   1.538728   .6271039     2.45   0.014     .3085303    2.768925
       single |    5.56889    2.08699     2.67   0.008     1.474816    9.662965
       female |  -1.084166   1.130253    -0.96   0.338    -3.301397    1.133066
       german |  -3.662533   8.965199    -0.41   0.683    -21.24968    13.92461
     employed |   .1616704    1.76554     0.09   0.927    -3.301812    3.625153
      retired |   2.586238   2.479464     1.04   0.297    -2.277756    7.450233
    onwelfare |   6.330971   2.757645     2.30   0.022     .9212643    11.74068
        bula1 |   .5676025   1.593737     0.36   0.722    -2.558851    3.694056
        bula2 |   2.226594   2.349539     0.95   0.343    -2.382527    6.835715
        bula3 |    1.77453     1.5462     1.15   0.251     -1.25867     4.80773
        bula4 |   .1674303    1.62071     0.10   0.918    -3.011937    3.346797
        bula5 |          0  (omitted)
        bula6 |          0  (omitted)
    smallcity |  -2.084923   1.019195    -2.05   0.041    -4.084291   -.0855547
        _cons |  -37.20347   16.40265    -2.27   0.023    -69.38074   -5.026193
-------------------------------------------------------------------------------

.         outreg2 using evs93_cantoni_20140812tables5_6, br dec(4) ctitle("`e(depvar)', , Bula FE, all controls, no EastBerlin") 
C:\Program Files (x86)\Stata12\ado\base/o/outreg2.ado
dir : seeout

. 
. log close
      name:  <unnamed>
       log:  Z:\GWA4 - Cantoni\D_Ergebnisse\evs93_cantoni_20140812tables5_6.log
  log type:  text
 closed on:  12 Aug 2014, 11:17:45
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
